Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_PROXY_COPY_DETAILS

`RC_PROXY_COPY_DETAILS` contains detailed information about proxy copy backups for databases registered in the recovery catalog.

This view is primarily intended to be used internally by Enterprise Manager.

Column | Datatype | Description
--- | --- | ---
`SESSION_KEY` | `NUMBER` | Session identifier. Use in joins with RC_RMAN_OUTPUT.
`SESSION_RECID` | `NUMBER` | Together with SESSION_STAMP, uniquely identifies output for this proxy copy operation from RC_RMAN_OUTPUT.
`SESSION_STAMP` | `NUMBER` | Together with SESSION_RECID, uniquely identifies output for this proxy copy operation from RC_RMAN_OUTPUT.
`DB_KEY` | `NUMBER` | The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`RSR_KEY` | `NUMBER` | Unique key for the row in `RC_RMAN_STATUS` corresponding to the job that created this proxy copy.
`COPY_KEY` | `NUMBER` | Unique identifier for this proxy copy.
`FILE#` | `NUMBER` | The absolute file number of the datafile that is proxy copied.
`HANDLE` | `VARCHAR2(1024)` | The proxy copy handle identifies the copy for purposes of restore operations.
`COMMENTS` | `VARCHAR2(255)` | A comment that contains further information about the media manager that stores this backup.
`MEDIA` | `VARCHAR2(80)` | Identifies the media manager that stores this backup.
`MEDIA_POOL` | `NUMBER` | The number of the media pool in which the copy is stored. This is the same value that was entered in the POOL operand of the Recovery Manager BACKUP command.
`TAG` | `VARCHAR2(32)` | Tag associated with this proxy copy.
`CREATION_CHANGE#` | `NUMBER` | The datafile creation SCN.
`CREATION_TIME` | `DATE` | The time corresponding to `CREATION_CHANGE#`.
`CHECKPOINT_CHANGE#` | `NUMBER` | Checkpoint SCN when the proxy copy was made.
`CHECKPOINT_TIME` | `DATE` | The time corresponding to `CHECKPOINT_CHANGE#`.
`OUTPUT_BYTES` | `NUMBER` | Sum of sizes of all output pieces generated by this proxy copy operation.
`COMPLETION_TIME` | `DATE` | Time when the proxy copy was completed.
`CONTROLFILE_TYPE` | `VARCHAR2(1)` | Possible values are: `B` for a normal control file, and `S` for a standby control file.
`KEEP` | `VARCHAR2(3)` | Indicates whether this backup has a retention policy different from the value for CONFIGURE RETENTION POLICY. Possible values are YES and NO.
`KEEP_UNTIL` | `DATE` | If the KEEP UNTIL TIME clause was specified, then this column shows the date after which this backup becomes obsolete. If the column is NULL and KEEP OPTIONS is not NULL, the backup never becomes obsolete.
`KEEP_OPTIONS` | `VARCHAR2(10)` | The KEEP options specified for this backup. Options can be LOGS (RMAN keeps the logs needed to recover this backup), NOLOGS (RMAN does not keep the logs needed to recover this backup), or NULL (the backup has no KEEP options and will be made obsolete based on the retention policy).
`OUTPUT_BYTES_DISPLAY` | `VARCHAR2(4000)` | Same value as `OUTPUT_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.